﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ConsultasDataSet" targetNamespace="http://tempuri.org/ConsultasDataSet.xsd" xmlns:mstns="http://tempuri.org/ConsultasDataSet.xsd" xmlns="http://tempuri.org/ConsultasDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConsultasConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConsultasConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.DoctorReg.Properties.Settings.GlobalReference.Default.ConsultasConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ConsultasTableAdapter" GeneratorDataComponentClassName="ConsultasTableAdapter" Name="Consultas" UserDataComponentName="ConsultasTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConsultasConnectionString (Settings)" DbObjectName="dbo.Consultas" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Consultas] WHERE (([Consulta] = @Original_Consulta) AND ([Data] = @Original_Data) AND ([Paciente] = @Original_Paciente) AND ([Medico] = @Original_Medico))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Paciente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paciente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Consultas] ([Data], [Paciente], [Medico]) VALUES (@Data, @Paciente, @Medico);
SELECT Consulta, Data, Paciente, Medico FROM Consultas WHERE (Consulta = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Paciente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paciente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Consulta, Data, Paciente, Medico FROM dbo.Consultas</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Consultas] SET [Data] = @Data, [Paciente] = @Paciente, [Medico] = @Medico WHERE (([Consulta] = @Original_Consulta) AND ([Data] = @Original_Data) AND ([Paciente] = @Original_Paciente) AND ([Medico] = @Original_Medico));
SELECT Consulta, Data, Paciente, Medico FROM Consultas WHERE (Consulta = @Consulta)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Paciente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paciente" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Medico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Consulta" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Data" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Data" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Paciente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Paciente" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Medico" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Medico" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Consulta" ColumnName="Consulta" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ZE\OS MEUS DOCUMENTOS\VISUAL STUDIO 2010\PROJECTS\DoctorReg\DoctorReg\CONSULTAS.MDF].dbo.Consultas" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Consulta" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Consulta" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Consulta" DataSetColumn="Consulta" />
              <Mapping SourceColumn="Data" DataSetColumn="Data" />
              <Mapping SourceColumn="Paciente" DataSetColumn="Paciente" />
              <Mapping SourceColumn="Medico" DataSetColumn="Medico" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DistritosTableAdapter" GeneratorDataComponentClassName="DistritosTableAdapter" Name="Distritos" UserDataComponentName="DistritosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConsultasConnectionString (Settings)" DbObjectName="dbo.Distritos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Distritos] WHERE (([Distrito] = @Original_Distrito))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Distritos] ([Distrito]) VALUES (@Distrito);
SELECT Distrito FROM Distritos WHERE (Distrito = @Distrito)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Distrito FROM dbo.Distritos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Distritos] SET [Distrito] = @Distrito WHERE (([Distrito] = @Original_Distrito));
SELECT Distrito FROM Distritos WHERE (Distrito = @Distrito)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Distrito" DataSetColumn="Distrito" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MédicosTableAdapter" GeneratorDataComponentClassName="MédicosTableAdapter" Name="Médicos" UserDataComponentName="MédicosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConsultasConnectionString (Settings)" DbObjectName="dbo.Médicos" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Médicos] WHERE (([Contribuinte] = @Original_Contribuinte) AND ([Nome] = @Original_Nome) AND ([Distrito] = @Original_Distrito))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Contribuinte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contribuinte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Médicos] ([Contribuinte], [Nome], [Distrito]) VALUES (@Contribuinte, @Nome, @Distrito);
SELECT Contribuinte, Nome, Distrito FROM Médicos WHERE (Contribuinte = @Contribuinte)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Contribuinte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contribuinte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Contribuinte, Nome, Distrito FROM dbo.Médicos</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Médicos] SET [Contribuinte] = @Contribuinte, [Nome] = @Nome, [Distrito] = @Distrito WHERE (([Contribuinte] = @Original_Contribuinte) AND ([Nome] = @Original_Nome) AND ([Distrito] = @Original_Distrito));
SELECT Contribuinte, Nome, Distrito FROM Médicos WHERE (Contribuinte = @Contribuinte)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Contribuinte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contribuinte" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Contribuinte" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Contribuinte" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Contribuinte" DataSetColumn="Contribuinte" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Distrito" DataSetColumn="Distrito" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PacientesTableAdapter" GeneratorDataComponentClassName="PacientesTableAdapter" Name="Pacientes" UserDataComponentName="PacientesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConsultasConnectionString (Settings)" DbObjectName="dbo.Pacientes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Pacientes] WHERE (([Codigo] = @Original_Codigo) AND ([Nome] = @Original_Nome) AND ([Distrito] = @Original_Distrito) AND ([Sexo] = @Original_Sexo) AND ([DataNascimento] = @Original_DataNascimento))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Sexo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNascimento" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Pacientes] ([Nome], [Distrito], [Sexo], [DataNascimento]) VALUES (@Nome, @Distrito, @Sexo, @DataNascimento);
SELECT Codigo, Nome, Distrito, Sexo, DataNascimento FROM Pacientes WHERE (Codigo = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Sexo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNascimento" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Codigo, Nome, Distrito, Sexo, DataNascimento FROM dbo.Pacientes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Pacientes] SET [Nome] = @Nome, [Distrito] = @Distrito, [Sexo] = @Sexo, [DataNascimento] = @DataNascimento WHERE (([Codigo] = @Original_Codigo) AND ([Nome] = @Original_Nome) AND ([Distrito] = @Original_Distrito) AND ([Sexo] = @Original_Sexo) AND ([DataNascimento] = @Original_DataNascimento));
SELECT Codigo, Nome, Distrito, Sexo, DataNascimento FROM Pacientes WHERE (Codigo = @Codigo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Sexo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNascimento" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Codigo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Nome" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Nome" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Distrito" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Distrito" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Sexo" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Sexo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNascimento" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="DataNascimento" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Codigo" ColumnName="Codigo" DataSourceName="[C:\DOCUMENTS AND SETTINGS\ZE\OS MEUS DOCUMENTOS\VISUAL STUDIO 2010\PROJECTS\DoctorReg\DoctorReg\CONSULTAS.MDF].dbo.Pacientes" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Codigo" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Codigo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Codigo" DataSetColumn="Codigo" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Distrito" DataSetColumn="Distrito" />
              <Mapping SourceColumn="Sexo" DataSetColumn="Sexo" />
              <Mapping SourceColumn="DataNascimento" DataSetColumn="DataNascimento" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ConsultasDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ConsultasDataSet" msprop:Generator_UserDSName="ConsultasDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Consultas" msprop:Generator_TableClassName="ConsultasDataTable" msprop:Generator_TableVarName="tableConsultas" msprop:Generator_TablePropName="Consultas" msprop:Generator_RowDeletingName="ConsultasRowDeleting" msprop:Generator_UserTableName="Consultas" msprop:Generator_RowChangingName="ConsultasRowChanging" msprop:Generator_RowEvHandlerName="ConsultasRowChangeEventHandler" msprop:Generator_RowDeletedName="ConsultasRowDeleted" msprop:Generator_RowEvArgName="ConsultasRowChangeEvent" msprop:Generator_RowChangedName="ConsultasRowChanged" msprop:Generator_RowClassName="ConsultasRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Consulta" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnConsulta" msprop:Generator_ColumnPropNameInRow="Consulta" msprop:Generator_ColumnPropNameInTable="ConsultaColumn" msprop:Generator_UserColumnName="Consulta" type="xs:int" />
              <xs:element name="Data" msprop:Generator_ColumnVarNameInTable="columnData" msprop:Generator_ColumnPropNameInRow="Data" msprop:Generator_ColumnPropNameInTable="DataColumn" msprop:Generator_UserColumnName="Data" type="xs:dateTime" />
              <xs:element name="Paciente" msprop:Generator_ColumnVarNameInTable="columnPaciente" msprop:Generator_ColumnPropNameInRow="Paciente" msprop:Generator_ColumnPropNameInTable="PacienteColumn" msprop:Generator_UserColumnName="Paciente" type="xs:int" />
              <xs:element name="Medico" msprop:Generator_ColumnVarNameInTable="columnMedico" msprop:Generator_ColumnPropNameInRow="Medico" msprop:Generator_ColumnPropNameInTable="MedicoColumn" msprop:Generator_UserColumnName="Medico" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Distritos" msprop:Generator_TableClassName="DistritosDataTable" msprop:Generator_TableVarName="tableDistritos" msprop:Generator_TablePropName="Distritos" msprop:Generator_RowDeletingName="DistritosRowDeleting" msprop:Generator_UserTableName="Distritos" msprop:Generator_RowChangingName="DistritosRowChanging" msprop:Generator_RowEvHandlerName="DistritosRowChangeEventHandler" msprop:Generator_RowDeletedName="DistritosRowDeleted" msprop:Generator_RowEvArgName="DistritosRowChangeEvent" msprop:Generator_RowChangedName="DistritosRowChanged" msprop:Generator_RowClassName="DistritosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Distrito" msprop:Generator_ColumnVarNameInTable="columnDistrito" msprop:Generator_ColumnPropNameInRow="Distrito" msprop:Generator_ColumnPropNameInTable="DistritoColumn" msprop:Generator_UserColumnName="Distrito">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Médicos" msprop:Generator_TableClassName="MédicosDataTable" msprop:Generator_TableVarName="tableMédicos" msprop:Generator_TablePropName="Médicos" msprop:Generator_RowDeletingName="MédicosRowDeleting" msprop:Generator_UserTableName="Médicos" msprop:Generator_RowChangingName="MédicosRowChanging" msprop:Generator_RowEvHandlerName="MédicosRowChangeEventHandler" msprop:Generator_RowDeletedName="MédicosRowDeleted" msprop:Generator_RowEvArgName="MédicosRowChangeEvent" msprop:Generator_RowChangedName="MédicosRowChanged" msprop:Generator_RowClassName="MédicosRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Contribuinte" msprop:Generator_ColumnVarNameInTable="columnContribuinte" msprop:Generator_ColumnPropNameInRow="Contribuinte" msprop:Generator_ColumnPropNameInTable="ContribuinteColumn" msprop:Generator_UserColumnName="Contribuinte" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Distrito" msprop:Generator_ColumnVarNameInTable="columnDistrito" msprop:Generator_ColumnPropNameInRow="Distrito" msprop:Generator_ColumnPropNameInTable="DistritoColumn" msprop:Generator_UserColumnName="Distrito">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Pacientes" msprop:Generator_TableClassName="PacientesDataTable" msprop:Generator_TableVarName="tablePacientes" msprop:Generator_TablePropName="Pacientes" msprop:Generator_RowDeletingName="PacientesRowDeleting" msprop:Generator_UserTableName="Pacientes" msprop:Generator_RowChangingName="PacientesRowChanging" msprop:Generator_RowEvHandlerName="PacientesRowChangeEventHandler" msprop:Generator_RowDeletedName="PacientesRowDeleted" msprop:Generator_RowEvArgName="PacientesRowChangeEvent" msprop:Generator_RowChangedName="PacientesRowChanged" msprop:Generator_RowClassName="PacientesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Codigo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnCodigo" msprop:Generator_ColumnPropNameInRow="Codigo" msprop:Generator_ColumnPropNameInTable="CodigoColumn" msprop:Generator_UserColumnName="Codigo" type="xs:int" />
              <xs:element name="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" msprop:Generator_UserColumnName="Nome">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Distrito" msprop:Generator_ColumnVarNameInTable="columnDistrito" msprop:Generator_ColumnPropNameInRow="Distrito" msprop:Generator_ColumnPropNameInTable="DistritoColumn" msprop:Generator_UserColumnName="Distrito">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sexo" msprop:Generator_ColumnVarNameInTable="columnSexo" msprop:Generator_ColumnPropNameInRow="Sexo" msprop:Generator_ColumnPropNameInTable="SexoColumn" msprop:Generator_UserColumnName="Sexo">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataNascimento" msprop:Generator_ColumnVarNameInTable="columnDataNascimento" msprop:Generator_ColumnPropNameInRow="DataNascimento" msprop:Generator_ColumnPropNameInTable="DataNascimentoColumn" msprop:Generator_UserColumnName="DataNascimento" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Consultas" />
      <xs:field xpath="mstns:Consulta" />
    </xs:unique>
    <xs:unique name="Distritos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Distritos" />
      <xs:field xpath="mstns:Distrito" />
    </xs:unique>
    <xs:unique name="Médicos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Médicos" />
      <xs:field xpath="mstns:Contribuinte" />
    </xs:unique>
    <xs:unique name="Pacientes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Pacientes" />
      <xs:field xpath="mstns:Codigo" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Consultas_Médicos" msdata:parent="Médicos" msdata:child="Consultas" msdata:parentkey="Contribuinte" msdata:childkey="Medico" msprop:Generator_UserChildTable="Consultas" msprop:Generator_ChildPropName="GetConsultasRows" msprop:Generator_ParentPropName="MédicosRow" msprop:Generator_UserRelationName="FK_Consultas_Médicos" msprop:Generator_RelationVarName="relationFK_Consultas_Médicos" msprop:Generator_UserParentTable="Médicos" />
      <msdata:Relationship name="FK_Consultas_Pacientes" msdata:parent="Pacientes" msdata:child="Consultas" msdata:parentkey="Codigo" msdata:childkey="Paciente" msprop:Generator_UserChildTable="Consultas" msprop:Generator_ChildPropName="GetConsultasRows" msprop:Generator_ParentPropName="PacientesRow" msprop:Generator_UserRelationName="FK_Consultas_Pacientes" msprop:Generator_RelationVarName="relationFK_Consultas_Pacientes" msprop:Generator_UserParentTable="Pacientes" />
      <msdata:Relationship name="FK_Médicos_Distritos" msdata:parent="Distritos" msdata:child="Médicos" msdata:parentkey="Distrito" msdata:childkey="Distrito" msprop:Generator_UserChildTable="Médicos" msprop:Generator_ChildPropName="GetMédicosRows" msprop:Generator_ParentPropName="DistritosRow" msprop:Generator_UserRelationName="FK_Médicos_Distritos" msprop:Generator_RelationVarName="relationFK_Médicos_Distritos" msprop:Generator_UserParentTable="Distritos" />
      <msdata:Relationship name="FK_Pacientes_Distritos" msdata:parent="Distritos" msdata:child="Pacientes" msdata:parentkey="Distrito" msdata:childkey="Distrito" msprop:Generator_UserChildTable="Pacientes" msprop:Generator_ChildPropName="GetPacientesRows" msprop:Generator_ParentPropName="DistritosRow" msprop:Generator_UserRelationName="FK_Pacientes_Distritos" msprop:Generator_RelationVarName="relationFK_Pacientes_Distritos" msprop:Generator_UserParentTable="Distritos" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>